package com.baide.sanguanheyi.sqlite;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @ClassName ContentDao
 * @Description TODO
 * @Author wangbing
 * @Date 2020/5/19 9:01
 **/
@Repository
public interface ContentDao extends JpaRepository<Content, String> {
    List<Content> findByTimeGreaterThanEqualAndTimeLessThanEqualAndVoyageNoContainingAndCustOrderContaining(Long starTIme, Long endTime, String voyageNo, String custOrder);
    List<Content> findByTimeGreaterThanEqualAndTimeLessThanEqualAndVoyageNoContainingAndCustOrderContainingAndCtOrderIs(Long starTIme, Long endTime, String voyageNo, String custOrder,String ctOrder);

    void deleteByTimeLessThan(Long time);
    List<Content> findByTimeLessThan(Long time);
}
